﻿CREATE PROCEDURE [dbo].[proc_Users_GetItem_UserName]
	(
		@UserName nvarchar(50)
	)
AS
	Select
	UserId,
	UserName,
	Password,
	RTX,
	Email,
	CompanyId,
	[Name],
	CreateDate,
	IsLockout,
	isnull(LastLoginDate,'1900-01-01') as LastLoginDate,
	FailedPasswordAttemptCount From aspnet_Users Where UserName=@UserName
	RETURN
